Introduction
FIFA!
The data that I will be using comes from FIFA, “Fédération
Internationale de Football Association”, which translates to,
International Federation of Association Football. This dataset
collects data from 900 World Cup matches that was played in its history
from Uruguay in 1930 to Russia in 2018. This data collected from GitHub.
What’s in the data? Can the next FIFA World Cup winner be
predicted?
Which Countries have hosted the FIFA World Cup?
|
host
|
|
Uruguay
|
|
Italy
|
|
France
|
|
Brazil
|
|
Switzerland
|
|
Sweden
|
|
Chile
|
|
England
|
|
Mexico
|
|
Germany
|
|
Argentina
|
|
Spain
|
|
USA
|
|
Japan, South Korea
|
|
South Africa
|
|
Russia
|
When was the First Match from the data?
|
stage
|
date
|
home_team
|
away_team
|
home_score
|
away_score
|
outcome
|
|
Group 1
|
1930-07-13
|
France
|
Mexico
|
4
|
1
|
H
|
|
Group 4
|
1930-07-13
|
Belgium
|
United States
|
0
|
3
|
A
|
When was the most recent match from the data?
|
stage
|
date
|
home_team
|
away_team
|
home_score
|
away_score
|
outcome
|
|
Final
|
2018-07-15
|
France
|
Croatia
|
4
|
2
|
H
|
Attendance Rate
How popular is the FIFA World Cup? How many attended? Which year had
the highest amount of audience?
|
year
|
host
|
attendance
|
games
|
winner
|
|
1994
|
USA
|
3568567
|
52
|
Brazil
|
|
2014
|
Brazil
|
3441450
|
64
|
Germany
|
|
2006
|
Germany
|
3367000
|
64
|
Italy
|
Has USA won the FIFA World Cup? Or close to reaching the FIFA
Cup?
|
year
|
host
|
winner
|
second
|
third
|
fourth
|
goals_scored
|
teams
|
games
|
attendance
|
|
1930
|
Uruguay
|
Uruguay
|
Argentina
|
USA
|
Yugoslavia
|
70
|
13
|
18
|
434000
|
What Nations have won the FIFA World Cup?
|
winner
|
year
|
|
Uruguay
|
1930
|
|
Italy
|
1934
|
|
Italy
|
1938
|
|
Uruguay
|
1950
|
|
West Germany
|
1954
|
|
Brazil
|
1958
|
|
Brazil
|
1962
|
|
England
|
1966
|
|
Brazil
|
1970
|
|
West Germany
|
1974
|
|
Argentina
|
1978
|
|
Italy
|
1982
|
|
Argentina
|
1986
|
|
West Germany
|
1990
|
|
Brazil
|
1994
|
|
France
|
1998
|
|
Brazil
|
2002
|
|
Italy
|
2006
|
|
Spain
|
2010
|
|
Germany
|
2014
|
|
France
|
2018
|
Which Nations have made it to Second Place?
|
second
|
|
Argentina
|
|
Czechoslovakia
|
|
Hungary
|
|
Brazil
|
|
Sweden
|
|
West Germany
|
|
Italy
|
|
Netherlands
|
|
Germany
|
|
France
|
|
Croatia
|
FIFA World Cup Winners count
Total Goals
Every match is exciting, especially when your team scores. Every one
standing up screaming Gol, bumping to each other and even spealing our
drinks to our neighbor. How many gols screams are there per game?
|
year
|
home_team
|
away_team
|
home_score
|
away_score
|
Total_Gols
|
|
1930
|
France
|
Mexico
|
4
|
1
|
5
|
|
1930
|
Belgium
|
United States
|
0
|
3
|
3
|
|
1930
|
Brazil
|
Yugoslavia
|
1
|
2
|
3
|
|
1930
|
Peru
|
Romania
|
1
|
3
|
4
|
|
1930
|
Argentina
|
France
|
1
|
0
|
1
|
|
1930
|
Chile
|
Mexico
|
3
|
0
|
3
|
|
1930
|
Bolivia
|
Yugoslavia
|
0
|
4
|
4
|
|
1930
|
Paraguay
|
United States
|
0
|
3
|
3
|
|
1930
|
Uruguay
|
Peru
|
1
|
0
|
1
|
|
1930
|
Argentina
|
Mexico
|
6
|
3
|
9
|
|
1930
|
Chile
|
France
|
1
|
0
|
1
|
|
1930
|
Belgium
|
Paraguay
|
0
|
1
|
1
|
|
1930
|
Bolivia
|
Brazil
|
0
|
4
|
4
|
|
1930
|
Uruguay
|
Romania
|
4
|
0
|
4
|
|
1930
|
Argentina
|
Chile
|
3
|
1
|
4
|
Ranked Most to Least amount of Total Gols in a match.
|
year
|
home_team
|
away_team
|
Total_Gols
|
|
1954
|
Switzerland
|
Austria
|
12
|
|
1938
|
Brazil
|
Poland
|
11
|
|
1954
|
West Germany
|
Hungary
|
11
|
|
1982
|
Hungary
|
El Salvador
|
11
|
|
1958
|
France
|
Paraguay
|
10
|
|
1930
|
Argentina
|
Mexico
|
9
|
|
1954
|
Hungary
|
South Korea
|
9
|
|
1954
|
West Germany
|
Turkey
|
9
|
|
1958
|
France
|
West Germany
|
9
|
|
1974
|
Yugoslavia
|
Zaire
|
9
|
|
1934
|
Italy
|
United States
|
8
|
|
1938
|
Cuba
|
Sweden
|
8
|
|
1950
|
Bolivia
|
Uruguay
|
8
|
|
1950
|
Brazil
|
Sweden
|
8
|
|
1954
|
Belgium
|
England
|
8
|
|
1962
|
Colombia
|
Soviet Union
|
8
|
|
1966
|
North Korea
|
Portugal
|
8
|
|
2002
|
Germany
|
Saudi Arabia
|
8
|
|
2014
|
Brazil
|
Germany
|
8
|
|
1930
|
Argentina
|
United States
|
7
|
How many Gols per Quadrennial occur?
Which Team has scored the most goals?
|
team
|
total_goals
|
|
Brazil
|
229
|
|
Argentina
|
137
|
|
West Germany
|
131
|
|
Italy
|
128
|
|
France
|
120
|
|
Spain
|
99
|
|
Germany
|
95
|
|
England
|
91
|
|
Hungary
|
87
|
|
Uruguay
|
87
|
How many matches made it to the Penalties stage?
|
year
|
stage
|
win_conditions
|
|
1982
|
Semifinals
|
West Germany won in penalties (5 - 4)
|
|
1986
|
Quarterfinals
|
France won in penalties (4 - 3)
|
|
1986
|
Quarterfinals
|
West Germany won in penalties (4 - 1)
|
|
1986
|
Quarterfinals
|
Belgium won in penalties (5 - 4)
|
|
1990
|
Round of 16
|
Republic of Ireland won in penalties (5 - 4)
|
|
1990
|
Quarterfinals
|
Argentina won in penalties (3 - 2)
|
|
1990
|
Semifinals
|
Argentina won in penalties (4 - 3)
|
|
1990
|
Semifinals
|
West Germany won in penalties (4 - 3)
|
|
1994
|
Round of 16
|
Bulgaria won in penalties (3 - 1)
|
|
1994
|
Quarterfinals
|
Sweden won in penalties (5 - 4)
|
|
1994
|
Final
|
Brazil won in penalties (3 - 2)
|
|
1998
|
Round of 16
|
Argentina won in penalties (4 - 3)
|
|
1998
|
Quarterfinals
|
France won in penalties (4 - 3)
|
|
1998
|
Semifinals
|
Brazil won in penalties (4 - 2)
|
|
2002
|
Round of 16
|
Spain won in penalties (3 - 2)
|
|
2002
|
Quarterfinals
|
South Korea won in penalties (5 - 3)
|
|
2006
|
Round of 16
|
Ukraine won in penalties (3- 0)
|
|
2006
|
Quarterfinals
|
Germany won in penalties (4 - 2)
|
|
2006
|
Quarterfinals
|
Portugal won in penalties (3 - 1)
|
|
2006
|
Final
|
Italy won in penalties (5 - 3)
|
|
2010
|
Round of 16
|
Paraguay won in penalties (5 - 3)
|
|
2010
|
Quarterfinals
|
Uruguay won in penalties (4 - 2)
|
|
2014
|
Round of 16
|
Brazil won in penalties (3 - 2)
|
|
2014
|
Round of 16
|
Costa Rica won in penalties (5 - 3)
|
|
2014
|
Quarterfinals
|
Netherlands won in penalties (4 - 3)
|
|
2014
|
Semifinals
|
Argentina won in penalties (4 - 2)
|
|
2018
|
Round of 16
|
Russia won in penalties (4 - 3)
|
|
2018
|
Round of 16
|
Croatia won in penalties (3- 2)
|
|
2018
|
Round of 16
|
England won in penalties (4 -3)
|
|
2018
|
Quarterfinals
|
Croatia won in penalties (4 - 3)
|
Summary
I was eager in learning what type of data was stored under the data
frame. Having to displays the given information with graphs demonstrates
a better understanding of Tournament.
Fans, Reporters, and Journalist try to predict who will take the
title but their are so much data missing to consider the winning Nation.
Who are the players? Is the weather under the same condition per
Quadrennial? Who are the referees? And more..
Every Tournament is inpredictable. Is just what makes it
exciting.